SELECT COUNT(1)
FROM FD_DICTIONARY T
WHERE 1                      =1
<#if (CODE!) != ''>
AND (INSTR (T.CODE, :CODE )  > 0
OR INSTR (T.NAME, :CODE )    > 0)
</#if>
<#if (VALUE!) != ''>
AND INSTR (T.VALUE, :VALUE ) > 0
</#if>
<#if (TYPE_ID!) != ''>
AND T.TYPE_ID = :TYPE_ID
</#if>
